package com.info.zhiduoduo.repository.mapper.system;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.info.zhiduoduo.repository.entity.system.EnterpriseIndustry;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  企业行业类别 Mapper 接口
 * </p>
 *
 * @author bob
 * @since 2020-04-02
 */
public interface EnterpriseIndustryMapper extends BaseMapper<EnterpriseIndustry> {

	@Select(" select * from zdd_enterprise_industry where  industry_name = #{industryName}")
	EnterpriseIndustry findByName(String industryName);

	@Select(" select * from zdd_enterprise_industry where industry_name like '%${name}%' and industry_state = 1 ")
	List<EnterpriseIndustry> list(@Param("name") String name);
}
